﻿CREATE TABLE [dbo].[forum_ClarifyNote] (
    [ClarifyNoteId] BIGINT           IDENTITY (1, 1) NOT NULL,
    [ThreadNoteId]  BIGINT           NOT NULL,
    [Text]          NVARCHAR (MAX)   NOT NULL,
    [Order] INT NOT NULL, 
		[CreatedBy]      UNIQUEIDENTIFIER NOT NULL,
    [CreatedDate]    DATETIME         CONSTRAINT [DF_forum_ClarifyNote_CreateDate] DEFAULT (getutcdate()) NOT NULL,
    [UpdatedBy]      UNIQUEIDENTIFIER NULL,
    [UpdatedDate]    DATETIME         NULL,
    CONSTRAINT [PK_forum_ClarifyNote] PRIMARY KEY CLUSTERED ([ClarifyNoteId] ASC)
);

